{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[13,9,17,16],[22,1,22,8],[24,1,24,8],[26,1,26,8],[28,1,28,8],[2,1,3,7],[11,1,12,7],[15,1,19,7],[14,1,14,7],[7,1,10,7],[42,1,43,8],[30,1,30,8],[34,1,34,8],[36,1,36,8],[38,1,38,8],[39,1,39,8]]}
[]
[null,"Patient Facing Services Analysis Report",null,null,null,null,null,null,null,"NOTE:"]
[null,"Start date applies to the reference date when searching 2 weeks past and 2 weeks into the future on specific reports",null,null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Start Date",null,null,null,null,null,null,null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[null,{"$f":"TODAY()","v":"2017-03-24"},null,null,null,null,null,null,null,"Excel 2003 - This report has not been written or tested with this version of Excel"]
[]
[null,"This report will be automatically minimised while compiling and close once completed, then the results saved into the same folder location you ran this file from and called \"PFS Online Analysis {date/time}.xls\"",null,null,null,null,null,null,null,"Current Version: 1.6"]
[null,null,null,null,null,null,null,null,null,"Last updated: 23/03/2017"]
[null,null,null,null,null,null,null,null,null,"Written by: Bradley Sieve (Vision)"]
[]
[null,"This report may be run as often as you like and will always collate up to the minute data"]
[null,null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[null,"*** IMPORTANT NOTE ***"]
[null,"Email addresses may be copied in bulk from this worksheet and pasted directly into the BCC field ONLY! of your email. DO NOT under any circumstances ever paste bulk patient email addresses into either the \"To\" or \"CC\" fields. If in any doubt do not send bulk emails. For NHS mail Bcc is located under the 3 dots (...) icon"]
[]
[]
[]
[]
[]
[null,"Notes about the Analysis tabs"]
[null,"Once the report has completed the Analysis tab will provide aggregated data across various areas to help practices target potential new patients to invite for online services and manage current patient online processes"]
[]
[null,"Only if there is a reference to 2 weeks past/present in the description text does it apply to those specific searches."]
[]
[null,"The remaining tabs are for reference and provide the raw data to help manage and target potential patients who would benefit from using online services."]
[]
[null,"Where 3 dots are referenced in any descriptions; this indicates that it is a sub search of the bold header above it."]
[]
[null,"TPP_PFS tab = Patients that have opted for an online account. This may or may not be active, which is reflected in the PFS_STATUS column"]
[null,"This includes additonal information such as demographics, 91B, 93440, Advice and 9lX"]
[null,"Use the drop down arrows on the top line of most sheets to filter data"]
[]
[null,"TPP_NOPFS tab = Patients that do not have an online account and the amount of LTC's per patient, to help target those that would benefit the most from online services"]
[]
[null,"NOPFS_RX tab = Provides a list of patients on multiple repeats with email addresses/mobiles if they exist"]
[]
[null,"18y_679k, 17y_679k, 16y_679k tabs provide an optional method of showing that you have NOT sent out an email/letter advising the patient to create their own online account"]
[null,"There is a target date column (which is the date the patient turned that age), and a days overdue column (showing the amount of days past this target date (age+birth date))"]
[null,"These tabs will only exist if there are patients in this age group that need to be informed."]
[]
[null,"Appts tab = The WEB column is slots maked as \"Reserved for Web\". The STATUS column is the slot status either UNAVAILABLE, BOOKED or OFFERED (i.e. not booked and available)"]
[]
[]
[null,"The remaining tabs are self-explanatory"]